block a database

block a database

am 08.04.2010 22:52:30 von ALEXANDER JOSE

--_2686d98c-a8d7-47e1-8799-040753203032_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable


As I can block a database so users can not connect without=20
affecting the other databases.


Atentamente=2C

Alexander Angel
DBA
058-02128018316
=20
____________________________________________________________ _____
Connect to the next generation of MSN Messenger=A0
http://imagine-msn.com/messenger/launch80/default.aspx?local e=3Den-us&sourc=
e=3Dwlmailtagline=

--_2686d98c-a8d7-47e1-8799-040753203032_
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable






r: rgb(255=2C 255=2C 255)=3B" title=3D"Como puedo bloquear una base de dato=
s para=20
que los usuarios no puedan conectarse sin afectar a las otras bases de=20
datos.">As I can block a database so users can not connect without=20
affecting the other databases.


Atentamente=2C

Alexander A=
ngel
DBA
058-02128018316


Con=
nect to the next generation of MSN Messenger=A0 msn.com/messenger/launch80/default.aspx?locale=3Den-us&sourc e=3Dwlmailtagli=
ne' target=3D'_new'>Get it now!

=

--_2686d98c-a8d7-47e1-8799-040753203032_--

Re: block a database

am 08.04.2010 22:56:17 von Kevin Grittner

ALEXANDER JOSE wrote:

> As I can block a database so users can not connect without
> affecting the other databases.

You probably want to use the pg_hba.conf file:

http://www.postgresql.org/docs/8.4/interactive/auth-pg-hba-c onf.html

-Kevin

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: block a database

am 15.04.2010 02:12:56 von Bruce Momjian

Kevin Grittner wrote:
> ALEXANDER JOSE wrote:
>
> > As I can block a database so users can not connect without
> > affecting the other databases.
>
> You probably want to use the pg_hba.conf file:
>
> http://www.postgresql.org/docs/8.4/interactive/auth-pg-hba-c onf.html

or:

ALTER DATABASE ... CONNECTION LIMIT connlimit

--
Bruce Momjian http://momjian.us
EnterpriseDB http://enterprisedb.com

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin